Forum Discussion

GMcCartney0607's avatar
GMcCartney0607
Occasional Contributor
2 months ago

CSV value dropping leading zeros

I have created a Keyword test that reads a CSV file for a data-driven loop. The file has string values enclosed in quotes, such as; ID, Area, Name "123435","001","John Doe" When reading the file, ...
GMcCartney0607's avatar
GMcCartney0607
Occasional Contributor
2 months ago

I have a schema.ini, but it only specifies the delimiter. Are you saying that I need to specify the field type (string) and length so that TC it will not convert and drop the leading zero for the quoted strings?

rraghvani's avatar
rraghvani
Icon for Champion Level 3 rankChampion Level 3
2 months ago

You didn't mention that you were using scheme.ini in your original post!?

Have you used the following dialog to create your Data-Driven Loop?

If you haven't used the above dialog, what exactly are you using to read your CSV file?

  • GMcCartney0607's avatar
    GMcCartney0607
    Occasional Contributor
    2 months ago

    Yes, this is how I define the loop variable.

    • rraghvani's avatar
      rraghvani
      Icon for Champion Level 3 rankChampion Level 3
      2 months ago

      The screenshot that I have provided, is the exact settings you require - the preview actually shows ID, Area and Name being read as strings, and maintaining leading zeros. Which can be seen in the output results.