I have a series of lines, names and address type stuff that came out in a funky format. To now import them into another system I need to put quotes (" ") around all the lines EXCEPT first and last line in a series.
Each series is separated by 1 or 2 blank lines
I am using the latest UltraEdit 12.20a+2 and could not figure out a viable regular expression yet based on what I have seen it seems like there should be one with the new Perl compatible engine.
thanks for any help and ideas
Alan
Sample:
sdfsa, bas,fsdf,adf,adsfafds,asdf,
ddflk,asd,df
sadfasdf,sadf,sdf
sadsadf,adfs,adsf
df adsf,sadf,asdf,sadf,sadf,
32 das fadf,adf
sa,df sadf
asdd fad fasdfasdfasdf,asd
23324 dsaf
3232,adfs,sadf,dsd
233223,4sd,asdf,sad
2323sd,dsf ,,dsfadfasdfsadf
sdfsa, bas,fsdf,adf,adsfafds,asdf,
ddflk,asd,df
sadfasdf,sadf,sdf
sadsadf,adfs,adsf
df adsf,sadf,asdf,sadf,sadf,
32 das fadf,adf
sa,df sadf
asdd fad fasdfasdfasdf,asd
23324 dsaf
3232,adfs,sadf,dsd
233223,4sd,asdf,sad
2323sd,dsf ,,dsfadfasdfsadf
Turn the above into:
sdfsa, bas,fsdf,adf,adsfafds,asdf,
"ddflk,asd,df"
"sadfasdf,sadf,sdf"
sadsadf,adfs,adsf
df adsf,sadf,asdf,sadf,sadf,
"32 das fadf,adf"
sa,df sadf
asdd fad fasdfasdfasdf,asd
"23324 dsaf"
"3232,adfs,sadf,dsd"
"233223,4sd,asdf,sad"
2323sd,dsf ,,dsfadfasdfsadf
Each series is separated by 1 or 2 blank lines
I am using the latest UltraEdit 12.20a+2 and could not figure out a viable regular expression yet based on what I have seen it seems like there should be one with the new Perl compatible engine.
thanks for any help and ideas
Alan
Sample:
sdfsa, bas,fsdf,adf,adsfafds,asdf,
ddflk,asd,df
sadfasdf,sadf,sdf
sadsadf,adfs,adsf
df adsf,sadf,asdf,sadf,sadf,
32 das fadf,adf
sa,df sadf
asdd fad fasdfasdfasdf,asd
23324 dsaf
3232,adfs,sadf,dsd
233223,4sd,asdf,sad
2323sd,dsf ,,dsfadfasdfsadf
sdfsa, bas,fsdf,adf,adsfafds,asdf,
ddflk,asd,df
sadfasdf,sadf,sdf
sadsadf,adfs,adsf
df adsf,sadf,asdf,sadf,sadf,
32 das fadf,adf
sa,df sadf
asdd fad fasdfasdfasdf,asd
23324 dsaf
3232,adfs,sadf,dsd
233223,4sd,asdf,sad
2323sd,dsf ,,dsfadfasdfsadf
Turn the above into:
sdfsa, bas,fsdf,adf,adsfafds,asdf,
"ddflk,asd,df"
"sadfasdf,sadf,sdf"
sadsadf,adfs,adsf
df adsf,sadf,asdf,sadf,sadf,
"32 das fadf,adf"
sa,df sadf
asdd fad fasdfasdfasdf,asd
"23324 dsaf"
"3232,adfs,sadf,dsd"
"233223,4sd,asdf,sad"
2323sd,dsf ,,dsfadfasdfsadf