View previous topic :: View next topic
|
Author |
Message |
viji_rags
New User
Joined: 04 Jun 2010 Posts: 24 Location: chennai
|
|
|
|
Hi,
Could you please let me know how to remove spaces in a dataset using syncsort.
Thank you. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Post some sample input data and the output you want from that data when your process is run.
Mention the recfm and lreckl of the input/output. |
|
Back to top |
|
|
viji_rags
New User
Joined: 04 Jun 2010 Posts: 24 Location: chennai
|
|
|
|
Hi,
If the input of the file is as below and the output file should not contain spaces.
Code: |
input:
¦"ABCD "¦"10 "¦"+ 0.00000000000"¦
output:
¦"ABCD"¦"10"¦¦"+0.00000000000"¦ |
Code'd
recfm=FB
lreckl =810 |
|
Back to top |
|
|
Akatsukami
Global Moderator
Joined: 03 Oct 2009 Posts: 1788 Location: Bloomington, IL
|
|
|
|
viji_rags, please post data, code, and anything else for which alignment may be significant in Code tags; as you will see for yourself, posting without them makes it very difficult to discern where the spaces are. |
|
Back to top |
|
|
viji_rags
New User
Joined: 04 Jun 2010 Posts: 24 Location: chennai
|
|
|
|
Hi,
Consider underscore as spaces. The spaces needs to be removed.
input:
¦"A_______"¦"1234___"¦"+____1.00"¦
output:
¦"A"¦"1234"¦"+1.00"¦
Thanks,
Vijay |
|
Back to top |
|
|
Ramsee
New User
Joined: 06 Jan 2011 Posts: 53 Location: Chennai
|
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Your original post has been "Code'd". You need to use the code tag when posting anything that needs to retain alignment.
Coded, your info looks like:
Code: |
input:
¦"ABCD "¦"10 "¦"+ 0.00000000000"¦
output:
¦"ABCD"¦"10"¦¦"+0.00000000000"¦ |
Let us know how the solution in the posted link works for you. |
|
Back to top |
|
|
|