ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

CSV file

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • CSV file

    Hi,


    Is it possible to change Semicolon instead of Comma in CSV file, If yes, then how, any program example to do the same please?


    Thanks...

  • #2
    i mean in field delimiter field can we use semicolon instead of comma ( in CPYTOIMPF Command)?

    if yes, then how ?


    Thanks..

    Comment


    • #3
      Cpytoimpf ... Flddlm(';') ...

      Comment


      • #4
        will system accept it as i can see just 3 acceptable values * tab, ',' and a character value so will ;(semicolon) be accepted as charater value by this command or it would fail?



        Thanks...

        Comment


        • #5
          Originally posted by John192 View Post
          will system accept it as i can see just 3 acceptable values * tab, ',' and a character value so will ;(semicolon) be accepted as charater value by this command or it would fail?



          Thanks...
          Why don't you try it and see what happens? Then you'll know.

          Comment


          • #6
            but even if it work if we change Semicolon instead of Comma in CSV file then also will it be called a CSV file?


            Any example to test it please?




            Thanks..

            Comment


            • #7
              "CSV" is the file extension, regardless of the data separator in the file. I generally prefer PIPE delimiter '|' because it's less likely to also be embedded in the data the way commas and semicolons might be.

              Comment


              • #8
                One of our suppliers uses a double dagger . It ends up as EBCDIC x'3F' in our programs. :-)

                PS: Scott Klement’s CSV Utility is a great help in dealing with CSV files in RPGLE.

                Comment


                • #9
                  i have a csv file but when trying to download it to local desktop it's format is not coming properly any idea what to correct so that it should have correct format in terms of avoiding junk values in this file.


                  thanks

                  Comment

                  Working...
                  X