Normal Topic control characters (Read 631 times)
Nancy
Member
*
Offline


No personal text

Posts: 9
Location: Pittsburgh
Joined: Feb 9th, 2006
control characters
Jun 27th, 2007 at 4:13pm
Print Post Print Post  
1.  Loved the conferece, Love 2.0, loved meeting you all   Kiss

2.  I have automated my export using filewrite programming.  Sometimes when we export and open our text file in Excel, some records are split onto two lines.  The most I can see in the raw data (using notepad) maybe a funny square, which I would think is a control character of some sort.

3.  My question is, is there a way to search for any/all control characters in a field?

Thanks

Nancy   Kiss
  
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: control characters
Reply #1 - Jun 27th, 2007 at 4:24pm
Print Post Print Post  
Hello Nancy,

I would guess that the reason it is spliting onto two lines is because you are exporting either a single line or multi line text element that has a line break in it. You can search for this by using the programmed retrieve spec below, you will need to replace Notes with the name of the element you are searching in.

{@InStr(Notes, @Newline()) > 0}

Glad to hear you enjoyed the conference, it was great to meet you as well.

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
Nancy
Member
*
Offline


No personal text

Posts: 9
Location: Pittsburgh
Joined: Feb 9th, 2006
Re: control characters
Reply #2 - Jun 27th, 2007 at 4:30pm
Print Post Print Post  
I already test for carriage returns and strip these.   Actually, we get a "/n" to replace the carriage return.

On these I get and small little square at the end of the last field and the balance of the fields for the same record are thrown onto a new line.

Next example I get, I'll throw it your way.
  
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: control characters
Reply #3 - Jun 27th, 2007 at 5:00pm
Print Post Print Post  
Just on some records right? Are you stripping the carriage returns using @Replace and @Newline() or are you using @Chr()?

Yeah, when you get an example shoot it off to me and I'll have a look at it.

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
Nancy
Member
*
Offline


No personal text

Posts: 9
Location: Pittsburgh
Joined: Feb 9th, 2006
Re: control characters
Reply #4 - Jun 27th, 2007 at 6:09pm
Print Post Print Post  
Just on some, very infrequent.

To remove the the line feed I use @replace and @newline.

Nancy
  
Back to top
 
IP Logged