Regex Line Feed

[BigEfromDaBX 25]

Im trying to replace a blank line with N/A using ^\n which i got from RegexBuddy.  Thanks for your help.

 

Code

set(#text1,"Bill Gates
Microsoft
3 Park Plaza

Irvine, California 92614
United States
3105551212


","Global")
set(#text2,$replace regular expression(#text1,"^\\n","N/A"),"Global")

Snapshot

[Marani 80]

Try this regex:

\n\s

[BigEfromDaBX 25]

 

Try this regex:

\n\s

 

Thanks.  But it didnt work.  It grabbed all the line feeds at the end of the lines and replaced them with N/A. I tried putting a ^ in the front of your code and it didnt do anything.  

 

Result

Bill Gates
Microsoft
3 Park PlazaN/AIrvine, California 92614
United States
3105551212N/A

[BigEfromDaBX 25]

 

Try this regex:

\n\s

 

 

Ok so used your code and then modified the replace field by putting a NEW LINE Command in front of N/A and Behind the N/A.  Thank you

 

Code

set(#text1,"Bill Gates
Microsoft
3 Park Plaza

Irvine, California 92614
United States
3105551212


","Global")
set(#text2,$replace regular expression(#text1,"\\n\\s","{$new line}N/A{$new line}"),"Global")