View previous topic :: View next topic
|
Author |
Message |
JennyMo
New User
Joined: 31 Mar 2008 Posts: 6 Location: Shanghai
|
|
|
|
When upload a txt format file, the row number shows not correct there.
I want to know how to config it to show the correct row number. Could anyone give me any solution to fix that? Thank you.
Attached is screen capture of the problem.
The txt file is like below:
Code: |
060386058JLWHITAKER 01060803010837590003300330-072600000000 0000
118528975RENEHREBECKI 01060803010837590003300297-072600000000 0000
136408732EMFRINK 010608030108 7590003300297-072600000000 0000
137587531JMBARTLING 01060803010837590003300297-072600000000 0000
152644948J BENJAMIN 01060803010837590003300297-072600000000 0000
152766004TJSILVEY 01060803010837590003300297-072600000000 0000
153683659SDALT 01060803010837920003300297-075900000000 0000
156508014MCWYNN 01060803010837590003300297-072600000000 0000 |
|
|
Back to top |
|
|
shrivatsa Warnings : 1 Active User
Joined: 17 Mar 2006 Posts: 174 Location: Bangalore
|
|
|
|
The difference I found is NUMBER DIS STD
Make it as
|
|
Back to top |
|
|
JennyMo
New User
Joined: 31 Mar 2008 Posts: 6 Location: Shanghai
|
|
|
|
It works, Thank you, shrivatsa. |
|
Back to top |
|
|
JennyMo
New User
Joined: 31 Mar 2008 Posts: 6 Location: Shanghai
|
|
|
|
There is still a problem.
When I view or edit that file again, the problem occurs again.
You see, I have saved the profile setting already. It is shows 'Number On STD' there. When I change it to "Number off", it works and shows the row num again.
Is there any permanent solution to fix that?
Code: |
****** ***************************** Top of Data ******************************
=PROF> ....TEST (VARIABLE - 129)....RECOVERY OFF WARN....NUMBER ON STD.........
=PROF> ....CAPS ON....HEX OFF....NULLS ON STD....TABS OFF......................
=PROF> ....AUTOSAVE ON....AUTONUM OFF....AUTOLIST OFF....STATS OFF.............
=PROF> ....PROFILE UNLOCK....IMACRO NONE....PACK OFF....NOTE ON................
=PROF> ....HILITE OFF CURSOR FIND..............................................
==MSG> -Warning- The UNDO command is not available until you change
==MSG> your edit profile using the command RECOVERY ON.
038605 8JLWHITAKER 01060803010837590003300330-072600000000 0000
852897 5RENEHREBECKI 01060803010837590003300297-072600000000 0000 |
|
|
Back to top |
|
|
Gnanas N
Active Member
Joined: 06 Sep 2007 Posts: 792 Location: Chennai, India
|
|
|
|
Is this PS or a member of PDS? |
|
Back to top |
|
|
JennyMo
New User
Joined: 31 Mar 2008 Posts: 6 Location: Shanghai
|
|
|
|
This is PS. |
|
Back to top |
|
|
shrivatsa Warnings : 1 Active User
Joined: 17 Mar 2006 Posts: 174 Location: Bangalore
|
|
|
|
First you need to create your PS and then do NUMBER OFF then upload your txt file to it and check whether its working or not? |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
try LOCKing your profile. |
|
Back to top |
|
|
JennyMo
New User
Joined: 31 Mar 2008 Posts: 6 Location: Shanghai
|
|
|
|
shrivatsa,
It doesn't work.
dbzTHEdinosauer,
Still not work.
Any other ideas? |
|
Back to top |
|
|
CICS Guy
Senior Member
Joined: 18 Jul 2007 Posts: 2146 Location: At my coffee table
|
|
|
|
JennyMo wrote: |
shrivatsa,
It doesn't work.
dbzTHEdinosauer,
Still not work.
Any other ideas? |
JennyMo,
Please define "It doesn't work"..... |
|
Back to top |
|
|
JennyMo
New User
Joined: 31 Mar 2008 Posts: 6 Location: Shanghai
|
|
|
|
I change profile setting to "Number off", save and profile lock. Exit that file.
When I view or edit that file again, it changed into "Number on STD" automatically.
****** ***************************** Top of Data ***********************
==MSG> -CAUTION- Profile changed to NUMBER ON STD (from NUMBER OFF).
==MSG> Data has valid standard numbers.
==MSG> -Warning- The UNDO command is not available until you change
==MSG> your edit profile using the command RECOVERY ON.
038605 8JLWHITAKER 01060803010837590003300330-072600000000 0000
852897 5RENEHREBECKI 01060803010837590003300297-072600000000 0000
640873 2EMFRINK 010608030108 7590003300297-072600000000 0000 |
|
Back to top |
|
|
UmeySan
Active Member
Joined: 22 Aug 2006 Posts: 771 Location: Germany
|
|
|
|
Hi Jenny !
==MSG> Data has valid standard numbers !!!
I did a little test. So here's a one-time-solution, let's see:
=PROF> ....TEXTXX (FIXED - 80)....NUMBER ON STD
=PROF> ....CAPS ON....HEX OFF....NULLS ON STD....TABS OFF
=PROF> ....HILITE OFF CURSOR FIND...................................
000100 000100THIS IS A LINE IN A PS WITH FB-80
000200 000200THIS IS A LINE IN A PS WITH FB-80
000300 000300THIS IS A LINE IN A PS WITH FB-80
000400 000400THIS IS A LINE IN A PS WITH FB-80
This PS-File looks quiet similar to your's, i think.
Change to number off and then shift the first six chars, or what you need, to the left to elininate them from the data-area.
=PROF> ....TEXTXX (FIXED - 80)....NUMBER OFF
=PROF> ....CAPS ON....HEX OFF....NULLS ON STD....TABS OFF
=PROF> ....HILITE OFF CURSOR FIND...................................
((6100 000100THIS IS A LINE IN A PS WITH FB-80
000200 000200THIS IS A LINE IN A PS WITH FB-80
000300 000300THIS IS A LINE IN A PS WITH FB-80
((6400 000400THIS IS A LINE IN A PS WITH FB-80
Save/Pf3 and re-edit the file
=PROF> ....TEXTXX (FIXED - 80)....NUMBER OFF
=PROF> ....CAPS ON....HEX OFF....NULLS ON STD....TABS OFF
=PROF> ....HILITE OFF CURSOR FIND...................................
000001 THIS IS A LINE IN A PS WITH FB-80
000002 THIS IS A LINE IN A PS WITH FB-80
000003 THIS IS A LINE IN A PS WITH FB-80
000004 THIS IS A LINE IN A PS WITH FB-80
Hope, this helps to get quickly rid of theese lousy numbers.
Regards, UmeySan |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
Remember also that ... for VB datasets NUMBER ON will f**k up the first 8 bytes of the line .... |
|
Back to top |
|
|
snammi
New User
Joined: 18 Mar 2009 Posts: 11 Location: Bangalore
|
|
|
|
Hi,
I am facing exactly similar problem. I tried all the solutions mentioned in this thread.. none worked .... could you please suggest me how to get rid of NUM ON STD profile setting permanently.. plz help!!
Regards,
Supriya |
|
Back to top |
|
|
Phrzby Phil
Senior Member
Joined: 31 Oct 2006 Posts: 1042 Location: Richmond, Virginia
|
|
|
|
After setting NUM OFF, then clear the numbers and save.
When you leave the numbers, it sees them next time and resets. |
|
Back to top |
|
|
|