Quote:
Originally Posted by paapachak
Hi,
I have a huge data of below format:
1 2 3 4 5
6 7 8 9 1
8 5 6 9 7
2 3 6 5 9
I need to read the data in following format
1
2
3
4
5
6
7
8
9
1
8 ....
Could anyone please help me, how to change from above format to below format??
Thanks in advance
|
What are the separators in the original data?
If it's a space then ;
Select what's to be modified
Open Advanced Find
Turn on use Wildcards
In the Find What Box type ([0-9])
(Where the smiley is a space or whatever is after the number)
In the replace box type ^13\1
This replaces all numbers followed by a space into the number followed by a carriage return.
Optionally to save your sanity cause word regex sucks use a proper editor
