+ Reply to Thread
Results 1 to 18 of 18

Rebuilt .csv file by comma

  1. #1
    Forum Contributor
    Join Date
    07-28-2018
    Location
    India
    MS-Off Ver
    2013
    Posts
    173

    Rebuilt .csv file by comma

    Hi,
    I have a code but when i run it i am getting incorrect output
    Please Login or Register  to view this content.
    Thnx For the Help
    Attached Files Attached Files
    Last edited by Leonardo1234; 02-01-2023 at 04:16 AM.

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,524

    Re: Rebuilt .csv file by comma

    Convert oo.csv to Actual Output.csv under the name of oo_Fixed.csv.
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    07-28-2018
    Location
    India
    MS-Off Ver
    2013
    Posts
    173

    Re: Rebuilt .csv file by comma

    Jindon Sir it is not putting comma in below lines
    GABRIELBUY191trigger pendingLIMIT182.05


    before the limit word & After the Limit Word
    Attached Files Attached Files

  4. #4
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,524

    Re: Rebuilt .csv file by comma

    Is that the only one or any other different combination?

    You must prepare all the possible data and the result that you want in the first place.

  5. #5
    Forum Contributor
    Join Date
    07-28-2018
    Location
    India
    MS-Off Ver
    2013
    Posts
    173

    Re: Rebuilt .csv file by comma

    Give me 5 min Sir

  6. #6
    Forum Contributor
    Join Date
    07-28-2018
    Location
    India
    MS-Off Ver
    2013
    Posts
    173

    Re: Rebuilt .csv file by comma

    Updated Jindon Sir
    Sorry Jindon Sir it will not be repeated

    & If u want create a new oo_Fixed.csv so plz kill oo.csv & Create new oo.csv it will be very helpful sir
    Last edited by Leonardo1234; 02-01-2023 at 04:19 AM.

  7. #7
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,524

    Re: Rebuilt .csv file by comma

    So, only LIMIT or SL with or without a hyphen and a single letter.
    change
    Please Login or Register  to view this content.
    to
    Please Login or Register  to view this content.

  8. #8
    Forum Contributor
    Join Date
    07-28-2018
    Location
    India
    MS-Off Ver
    2013
    Posts
    173

    Re: Rebuilt .csv file by comma

    Jindo Sir there will be SELL word also
    MCXSELL25trigger pendingSL1504.95

  9. #9
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,524

    Re: Rebuilt .csv file by comma

    Please Login or Register  to view this content.

  10. #10
    Forum Contributor
    Join Date
    07-28-2018
    Location
    India
    MS-Off Ver
    2013
    Posts
    173

    Re: Rebuilt .csv file by comma

    Thnx Alot Jindon Sir
    Have a Exciting Day

  11. #11
    Forum Contributor
    Join Date
    07-28-2018
    Location
    India
    MS-Off Ver
    2013
    Posts
    173

    Re: Rebuilt .csv file by comma

    Jindon Sir how we will do for the below file
    Attached Files Attached Files

  12. #12
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,524

    Re: Rebuilt .csv file by comma

    Please Login or Register  to view this content.

  13. #13
    Forum Contributor
    Join Date
    07-28-2018
    Location
    India
    MS-Off Ver
    2013
    Posts
    173

    Re: Rebuilt .csv file by comma

    Thnx Alot Jindon Sir

    Have a Awesome Day

  14. #14
    Forum Contributor
    Join Date
    07-28-2018
    Location
    India
    MS-Off Ver
    2013
    Posts
    173

    Re: Rebuilt .csv file by comma

    Jindon Sir how we will do for the below file
    Attached Files Attached Files

  15. #15
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,524

    Re: Rebuilt .csv file by comma

    This will be endless...

    Put all source data in one csv and create output csv.

  16. #16
    Forum Contributor
    Join Date
    07-28-2018
    Location
    India
    MS-Off Ver
    2013
    Posts
    173

    Re: Rebuilt .csv file by comma

    No jindon Sir this is the Last File

  17. #17
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,524

    Re: Rebuilt .csv file by comma

    Thanks for no rep.
    Please Login or Register  to view this content.

  18. #18
    Forum Contributor
    Join Date
    07-28-2018
    Location
    India
    MS-Off Ver
    2013
    Posts
    173

    Re: Rebuilt .csv file by comma

    Rep Done Jindon Sir
    No Doubt u r a Expert & rep is a very small thing

    Thnx Alot Jindon Sir for ur Great Help
    Have a beautiful weekend

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 5
    Last Post: 05-25-2020, 01:12 AM
  2. [SOLVED] Dynamic menu arrays (custom ribbon tab) only partly rebuilt after loss of state recovery
    By mc84excel in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-11-2013, 09:57 PM
  3. Macro to convert comma delimited csv file to excel file??
    By sanjeevpandey in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-15-2012, 05:31 AM
  4. [SOLVED] How do I convert an excel file into a comma separated values file
    By Conquerer in forum Excel General
    Replies: 3
    Last Post: 08-17-2006, 04:25 PM
  5. Comma Delimited file
    By \(Joseph in forum Excel General
    Replies: 1
    Last Post: 03-15-2006, 05:20 PM
  6. [SOLVED] Saving multi-tab excel file created from comma delimited text file
    By Marcus Aurelius in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-19-2005, 01:20 PM
  7. Replies: 1
    Last Post: 05-03-2005, 06:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1