Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (5)

Resolved 0A line feed string

  1. Advice
0
Votes
Undo
  1. John Vanleeuwe
    John Vanleeuwe
  2. PowerBuilder
  3. Wednesday, 3 January 2024 01:04 AM UTC

 Hi guys,

i am receiving data from external parties.

We have noticed that some of these send us data with hex 0A character (line feed)

My question is how can i detect this when the data is in a PB string variable ?

I do know the character is there, because when i copy the contents it to the clipboard and then paste it in the site www.hexed.it i can see the 0A character.

 

TIA

John

 

 
Problems with pictures in PB22
Print WebBrowser
Accepted Answer
mike S
mike S Accepted Answer Pending Moderation
  1. Wednesday, 3 January 2024 03:49 AM UTC
  2. PowerBuilder
  3. # Permalink

you can use: RightTrim( string, TRUE) to remove all whitespace at the end.

https://docs.appeon.com/pb2021/powerscript_reference/trim_func.html

 

the list of which whitespace the TRUE will remove is here:  LeftTrim - - PowerScript Reference (appeon.com)

 

Comment
There are no comments made yet.
Responses (5)
John Vanleeuwe
John Vanleeuwe Accepted Answer Pending Moderation
  1. Tuesday, 9 January 2024 06:09 AM UTC
  2. PowerBuilder
  3. # 1

This one worked for me , not sure why Chris suggestion with the pos didnt work :(

 

 
Comment
There are no comments made yet.
John Vanleeuwe
John Vanleeuwe Accepted Answer Pending Moderation
  1. Tuesday, 9 January 2024 06:08 AM UTC
  2. PowerBuilder
  3. # 2

hi Chris, that's the weird thing , i've tried this ,but it didnt work :(

 

 
Comment
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Tuesday, 9 January 2024 20:26 PM UTC
Yes, it should. I would need a test file in order to validate.
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 3 January 2024 01:30 AM UTC
  2. PowerBuilder
  3. # 3

Hi John;

  Use the POS() command & look for a "~r" (line feed). Then use the Replace() command, replacing that with a "".  HTH

FYI: https://docs.appeon.com/pb2022/powerscript_reference/xREF_36556_Special_ASCII.html

Regards ... Chris 

Comment
Arnd Schmidt
  1. Arnd Schmidt
  2. Tuesday, 9 January 2024 21:04 PM UTC
A line feed would be '~n'.

https://en.wikipedia.org/wiki/Newline
  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Tuesday, 9 January 2024 22:32 PM UTC
That would be a "New Line" now a CR. However, that could be what John is encountering.
  1. Helpful
Arnd Schmidt
  1. Arnd Schmidt
  2. Tuesday, 9 January 2024 23:13 PM UTC
sigh...I wonder if the PowerBuilder doc is wrong claiming "Newline" to be a line feed (LF) aka '~n' and Carriage Return (CR) to be '~r'.







  1. Helpful
There are no comments made yet.
John Vanleeuwe
John Vanleeuwe Accepted Answer Pending Moderation
  1. Wednesday, 3 January 2024 01:07 AM UTC
  2. PowerBuilder
  3. # 4

Ideally i need to detect and replace it with ''.

Forgot to include this info in my original post.

 

TIA

 

 
Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.