Search results

  1. A

    Extract the data between two consecutive comma set

    Can you expend a bit as to how i can add Dlook with extractdata ?
  2. A

    Extract the data between two consecutive comma set

    Paul, please help.
  3. A

    Extract the data between two consecutive comma set

    Data is in .TXT file format. I have tried import the file but import function is not working fine as it does not import all fields. Adressing this import issue, microsoft guy said to me that "all records in import file must have the same number of fields of matching datatypes. In your case...
  4. A

    Extract the data between two consecutive comma set

    So here is what i want to achieve next. I have wrote this on Microsoft access groups but it seems guys over there are not much into solving my prob . I am doing financial analysis on product wise customer's data. Data in my file contains different structure of records and each record structure...
  5. A

    Extract the data between two consecutive comma set

    However, i dont have idea where exactly in the code but i wil trying that. Lets see if i managed to add this simple thing :( otherwise will buzz you again now leaving office. speak tomorrow
  6. A

    Extract the data between two consecutive comma set

    Can you please also assist to add following in above code: to extract the values where line starts with 102 only
  7. A

    Extract the data between two consecutive comma set

    You are a star Paul. Thanks for this code courtesy...
  8. A

    Extract the data between two consecutive comma set

    I read it from end to end. All gone above my head. :(
  9. A

    Extract the data between two consecutive comma set

    Amigo, Thanks for replying. I am new in Access world. Can you guide me through how to put this function in place.? my data is in [Field1]
  10. A

    Extract the data between two consecutive comma set

    102,34112,021502503130010010000,QAR,1,24,1,{NULL:0},{5:Y},6,14.5,31-MAR-2011 above data is in one field , i want and expression to extract the data between two consecutive comma set by specifying the comma range. for example if i specify range 2 to 3 then formula should return...
Top Bottom