Forum Discussion

MarkSchofer's avatar
MarkSchofer
Frequent Contributor
4 years ago

Detailed Question About Formatting

I have a python Script that reads from a spreadsheet Long Story Short It Reads Payee, PayDate and Payment Amount def LookForCash(): # Checking the 'Cash Recipt Links' activity # Log.Message("Dri...
Object Recognition
TechCorner
  • Marsha_R's avatar
    Marsha_R
    4 years ago

    Can I AQstring the ValuesArray here? 

    Probably, since the value is a string.  Try it and see.

     

    Is there a better way? 

    I never got into using tables, although I know some here do.  I'd be reading straight from the spreadsheet or an equivalent .csv file.

     

     

Marsha_R's avatar
Marsha_R
Moderator
4 years ago

Can I AQstring the ValuesArray here? 

Probably, since the value is a string.  Try it and see.

 

Is there a better way? 

I never got into using tables, although I know some here do.  I'd be reading straight from the spreadsheet or an equivalent .csv file.

 

 

  • MarkSchofer's avatar
    MarkSchofer
    Frequent Contributor
    4 years ago
    wow worked first try PropArray = ["ObjectType","ObjectLabel"] ValuesArray = ["Link",aqConvert.CurrencyToFormatStr(4077.94,2,False,False,True)];
  • MarkSchofer's avatar
    MarkSchofer
    Frequent Contributor
    4 years ago

    The spreadsheet part I have down fine.   I read the vales from the spreadsheet and then compare them the values on a web page. It is the conversion from the spreadsheet to the web page. The webpage (link) have commas and dollar signs and that is where the compare breaks down. But I had a brain storm while typing this (THANK YOU) and as you said I will heed your suggestion 

     

    Thank you for your thoughtful response

    • Marsha_R's avatar
      Marsha_R
      Moderator
      4 years ago

      Happy to trigger brain storms any time.  ðŸŒ©

      • MarkSchofer's avatar
        MarkSchofer
        Frequent Contributor
        4 years ago

        That is what this job is all about. Me a non Python programmer figuring stuff out on the fly. Its nice to actually get some human feedback.
        Happy Friday 13th