Community

it's still a little confusing, but i will look at it some more.

it did work after i opened a new textpad and copited the data into it.

thanks again

could you explain out what this is doing? i went thru the help and forums but i'm still a little lost.

Find what: ^(([^,]*,){3})"?([^,]*), *([^"]*)"?$
Replace with: \1\3\n\1\4

thanks in advance

i opened a new textpad and copied the data into it and everything worked. not sure why the other textpad would not work.

Thanks again!!

here is another sample, no spaces at the beginning or end of the line. but when i highlight the data there is an extra space at the end of each line, possible hidden carriage return??

Alpine,1,1,AK
Alyeska (Trans Alaska Pipeline),2,1,AK
Basin,3,1,"NM,TX,OK"
Buckeye,14,2,"IL,IN,MI,OH,PA,NJ,NY,CT,MA ...

thank you for your response.

i get an error: Cannot find regular expression.

i changed the option to use Posix and regular expression is checked.

also could you decipher the expression for me? i'm having a problem understanding it so i can trouble shoot why it's not working for me.

thanks

how do i parse out the data inside the double quotes so it will result in seperate rows of data? here are 3 rows od data for example. 1st row does not have double quotes so there is not anything to do but the next 2 rows of data does.

Data:
Alyeska (Trans Alaska Pipeline),2,1,AK
Basin,3,1,"NM, TX ...

After reading your post, the help docs you referred me and changing the settings in the Textpad - it is all good now.

appreciate your help!!

Hello,

I have been using TextPad and it's basic tools for years. Now i want to get into more of the advance stuff. I have a list:
=Datasheet!I94
=Datasheet!H94
=Datasheet!G94
=Datasheet!F94
=Datasheet!E94
=Datasheet!D94
=Datasheet!C94
That i want to increment the last 2 characters up by one

i.g ...