Member Avatar for jam2010

Hi Everyone,

Can anyone pls help me out......with my requirement, i am struggling since 3 days. Please find the requirement below

my file contains below data


Code:
R1|Array/Network Resistor - VIP|V_RES_CLASS|V_MOUNT_FEATURE|SURFACE MOUNT|AND|8533.10.00.20|8533.10.00.20|
R1|Array/Network Resistor - VIP|V_RES_NW_CLASS|V_TECHNOLOGY|CARBON*||8533.10.00.20|8533.10.00.20|
R4|Array/Network Resistor - VIP|V_RES_CLASS|V_MOUNT_FEATURE|THROUGH HOLE MOUNT|AND|8533.10.00.57|8533.10.00.57|
R4|Array/Network Resistor - VIP|V_RES_NW_CLASS|V_TECHNOLOGY|CARBON*||8533.10.00.57|8533.10.00.57|
R7|Array/Network Resistor - VIP|V_RES_CLASS|V_MOUNT_FEATURE|SURFACE MOUNT|AND|8533.21.00.10|8533.21.00.25|
R7|Array/Network Resistor - VIP|V_RES_NW_CLASS|V_TECHNOLOGY|!CARBON*|AND|8533.21.00.10|8533.21.00.25|
R7|Array/Network Resistor - VIP|V_PRT_CLASS|V_MFR_PKG_DESC|DIP*||8533.21.00.10|8533.21.00.25|


i need a perl script to generate single sql statement for the unique column 1 attribute as below

select a.V_MOUNT_FEATURE, b.V_TECHNOLOGY, c.V_MFR_PKG_DESC from V_RES_CLASS a, V_RES_NW_CLASS b, V_PRT_CLASS c where a.V_MOUNT_FEATURE='SURFACE MOUNT' and b.V_TECHNOLOGY not like 'CARBON%' and c.V_MFR_PKG_DESC like 'DIP%';

Please help me out.

  • 2 Contributors
  • 1 Reply
  • 86 Views
  • 16 Hours Discussion Span
  • Latest Post Latest Post by JeoSaurus
Member Avatar for JeoSaurus

Hello jam2010, welcome to the forum!

Could you show us what you have tried so far? We might be able to help you get it to work, but I don't know that anyone here will write a script to spec from scratch.

Thanks!
-G

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.