Community

Great. Thanks for the tip. I did manage to find the answer later on but thanks for the prompt assistance.

Can you set the view visible spaces option as a defauilt setting? I'd like it switched on always but couldn't find the option to set it as a default setting. Thanks.

Thanks again guys for the effort. When two or more commas exist between the quotes, I just rerun the macro and it cleans it up until all commas have been removed and the text appears as it should (on the one line).

Appreciate the assistance. Many thanks for your kind support. Even though the solution isn't solved entirely, it's telling me a bit more about what TextPad can and can't handle.

I was wondering if anyone could assist please? Say I had data in the following format...

1 (id)
xxx
2
3
rrr
4
2 (id)
aaa
1
3
zzz
6
3 (id)
xxx
2
3
rrr
4

I would like to insert a "+" symbol in front of the id field [see the fields marked with (id)]. The data should look like this...

+1
xxx
2
3
rrr ...

Thanks for the prompt reply again. I tried both techniques and fully tested them. They both work splendidly well. I've managed to save the search & replace techniques you provided into macros. I can run these in a particular order that converts and cleans the data files into the exact format I ...

Many thanks for the quick replies and for a solution. Much appreciated.

I understand the logic behind the solution. I'm not totally sure of the search and replace syntax? I was looking up regular expression information but as I am inexperienced with TextPad, I'm not sure what...

Find what ...

I have a data file which contains lots of text. The format is something like this...

eg.
1,5,8,3,4,"aaa",2,4,"zzz",3,4

I'd like to convert this text to read down sequentially as follows...
1
5
8
3
4
"aaa"
2
4
"zzz"
3
4

That's easy to do in the above example as I replace the comma with a carriage ...